Which cities have the most drinking fountains?

Summer has seen heatwaves hit Europe and the US, with residents and tourists seeking the nearest drinking fountain.