Welcome to TPT!
Most snake species couldn't handle the humidity of a waterfall... so definitely need to be sure of the needs of your species.
Also +1 that many reptiles love pooping in their water bowls, so bacteria could become a major issue. In zoo setups, the keepers drain, pressure wash, and sterilize the anaconda (etc) pools frequently.