I've been to Germany, the Netherlands, Scandinavia, Spain and France. Only France had a few in touristy beach areas. The total low is Germany, where the whole country has only 1300 (given ~100 cities with >100k ppl, that is just a ridiculous 13 per large city): https://www.bmuv.de/pressemitteilung/staedte-und-gemeinden-m...
Amsterdam Schiphol Airport has drinking fountains at most if not all toilets[0]. There's been a short period recently apparently where they were getting replaced and so were unavailable.
The city of Amsterdam has 500 fountains or bottle filling stations[1]. The rest of the country has at least 2400 more[2].
