I'm struggling to think of any parks or high pedestrian areas around me that don't have a public fountain, nor in any of the cities I've lived in. Like, yeah, you're not going to have a fountain out in the middle of a parking lot. But they, to my recollection, seem to be everywhere that people tend to be walking a lot.

As for Europe, they also tend to be in a lot of high pedestrian areas, but really only in southern Europe (Italy, Spain, etc). In northern Europe it seems that everyone is just fine with being constantly dehydrated.