Stumbled upon this the other day. I wanted to try and go to the top, but the stairway was surrounded by this pretty unclimbable fence.
If I were you I would stay away from live water supply infrastructure. Since 911 new laws came out regarding water supply, don't get caught.