There are plenty of chances to find a place for a fountain. Most obvious places are roundabouts, main squares, isles separating 2 sides of a road, parks, or lakes.
The static water feature is a typical earmark of classic fountains. It is not the changing of the waterscape, that causes the impression, but the form, resplendence of water, and the collision of water and stone. These fountains are in most cases decorated by stone, bronze, or glass artwork.