Cattail Fountains make a lot of sound and display.  The water shoots straight up from the top and falls down into the center, where the leaves act as a barrier for splash-out.