Water fountains with lighting