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.