Fountains In New Orleans
http://zionxocx109.angelfire.com/index.blog/1621411/transient-tutorial-to-h2o-gardening/
The water disappears into the bottom, is then gathered in an underground basin, and is pumped again up for the waterfall. Usually the drinking water basin is roofed with rock or stone for any purely natural transition.