Unable to answer "Is drinking water available here? If so, what is its source?" – Drinking Water – https://osm.org/node/5929910354 via StreetComplete 63.0:

Decorative fountain (closed in winter). Probably not drinkable?