Blatantly stealing an idea from someone else, I've recently added a little Ikea clip on LED light for evening viewing. Much better for the fish, and makes the tank look wonderfully mysterious.
I love this look too, have some low power led night lights in my hood for a similar effect. The ripple effect is huge too! (long exposure pic)