Hello and welcome,
Yes, when it comes to water fountains, there has to be something distinct about it. There’s even an example here:
A drinking fountain that only functions as such is pretty ordinary, something people see often, so it’s quite indistinct. However, there are drinking fountains out there that may also be a sculpture or be painted with unique art, and these typically make the fountains eligible.
I like to think of this similar to utility boxes next to stop lights. Some utility boxes these days are getting unique art applied to them as a way to liven up the area. I love seeing the different ones in my area, so they make great places to explore, and I can see them being used by people as places to meet up. A plain metal or single color utility box isn’t very interesting, unless you’re an electrician or electrical engineer, and would hardly get used as some place to meet up with others.