Mark Mander’s Fountain at Rokin in Amsterdam, in front of Scheltema Bookstore, is my favorite in Amsterdam. One of the most remarkable things of it is that the water disappears underneath the pedestal. You can’t see where it goes.
And in Frisia, in the Northeastern part of the country (Netherlands), there are a couple of interesting ones as part of the 11 Fountains built in the 11 cities of the ‘Elfstedentocht’, a seating tournament when the winters were cold enough yet to allow for many people to be on the ice all at once, erected when Leeuwarden was Cultural Capital of Europe in 2018. International artists made them. I like the ones in Stavoren and Leeuwarden best. Here are some pics.
In Stavoren, by Mark Dion. Sadly, it didn’t spout when I was there on account of the strong wind of the day before. There was not enough water left. It’s called The Fish (obviously!):
In Leeuwarden, by Jaume Plensa. It’s a so called steam fountain. It’s called ‘Love’: