New Orleans Style Fountains
http://profiledirtsods5xcd.nation2.com/fast-guidebook-to-water-gardening
The h2o disappears into the ground, is then gathered in an underground basin, and is also pumped again up to the waterfall. Normally the water basin is roofed with rock or stone for the purely natural transition.