Fountains can be found in Parks and near some buildings in SimCity
They make your city look prettier.
