here you want citizens to upgrade their homes into rather nice dwellings, provide them with access to fresh water from a fountain.

Fountains receive their sweet water from reservoirs. Reservoirs automatically come with underground pipes surrounding them, and fountains have to be built within a reservoir's pipe area to be supplied with water.

Fountains supply a reasonably large area around them with their water. They don't affect the desirability of their surrounding area.