Talk to Tiff, and they'll start you on The Fountain Rider quest, requiring you to craft a Bonker (if you haven't already) and to fix three valves, which will restore water pressure to the fountain.