This custom backyard fountain was designed so that water would spill out of a tiled wall and into a raised pool. Often fountains like this double as spas.

See spa pictures.