Here is a video of a newly completed, custom rain waterfall feature:

Below you can see a variety of custom water features including a tile slide, a rock waterfall,
a tanning shelf with foam jets, and a spill-over spa: