HoMedics WFL-SLVS Envirascape Silver Springs Illuminated Relaxation Fountain with Natural Stones
I received this as a Christmas gift, and so far it's been a pleasant diversion. It has one best view (as the back is unfinished) so it must be placed against a wall. It works best when full of clean water; the pump must be completely immersed, or an unwelcome grinding noise will result. Enclosed documents also explain that dust or heavy water can lead to increased noise.
I found an ideal place for mine, on a sideboy in a hallway, where the sound of the running water can be heard from two rooms, and where the light can be kept low so the silvery spotlights can sparkle in the running water. It's not made of stone (though polished stones are included for meditative and decorative purposes), but the black plastic is unobtrusive, and it's quite soothing. What more do you expect for $20 from the drugstore?