I got submersible fountain lights at Harbor Freight. There are three in the 12" deep base of the fountain (ya can't see the base, but where do you think those lions are spouting that water into?) I also put a submersible light in the top of the fountain to illuminate not only the water cascading over the edges, but also the constantly dancing water spout.
If any of you make a trip to Memphis to see us, we'll dye the water purple green and gold.
Which is a designer paint color termed "Turd Brown" by Sherwin Williams.