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

Open water pipe. 
More like a stream

Attached photo(s):
https://streetcomplete.app/p/323299.jpg