Switzerland has a lot in my experience. At least the few cities that I visited. They are also very well mapped on openstreetmap, so it was easy to search for a nearby one with osmand whenever I was thirsty.
I presume you mean regular small to tiny fountains. Yes very frequent here, my small village has at least 5 of those. Unless there is an explicit sign that its not drinkable all have drinking water.
Good thing indeed, but then you go ie to France where you have sometimes such fountains too, and often reverse applies - don't drink unless its singed as drinkable.
The rule is the same if France though. Water is drinkable by default and will be signed "eau non potable" if it isn't (and even then it usually means it's never tested, not that it's unsafe).
