https://overpass-turbo.eu , the sample query is already for drinking fountains. I navigated so Berlin is on the map and clicked Run, and it shows me all drinking water fountains on the map. A few of them even have image links, for example: https://imgur.com/d6UheOw