New Orleans Style Fountains
https://profilerusticga.livejournal.com/446.html
The water disappears into the bottom, is then collected in an underground basin, and is also pumped back up for the waterfall. Normally the drinking water basin is roofed with rock or stone for just a organic changeover.