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

Used to be a water fountain, no longer in use

Attached photo(s):
https://westnordost.de/p/223608.jpg