Definitely NO on the sand. Not good at all for BP's or most other snakes.
As for the waterfall...not really a good idea either. The snake can get stuck in the pump/filter mechanism. And even if you can rig it up so there's no chance of the snake getting into places it shouldn't, it will be a HUGE pain to clean and maintain, especially when the snake poops in it.