Fountain of the Day

I don’t really understand how these fountains work but I dig ’em. How do these fountains work? You know cycle the water etc.?