I'm not super well travelled, but of the ~9 of the ~10 countries I've been to, including where I live (New Zealand) it's normal to drink tap water. Thailand was the exception for me.
Water fountains are somewhat normal in New Zealand and Australia.
It definitely wasn't normal in Spain. I think they called it "water from the lake" or something dirty sounding like that. And don't bother asking for ice cubes in some parts of Europe, they might have to chisel it off of a big hunk of ice for you (happened to my mother in law)
Water fountains are somewhat normal in New Zealand and Australia.