Waterfall drinking fountain for reptiles