Ever since The Wind Waker, I've always thought their fountains were just portals to the fairy world...However, here, the Great Fairy Tera's dialogue suggests that it's just a bunch of water beneath the surface.