This is actually one of the most fascinating aspects of modern society to me. I can't resist opportunities to tour local infrastructure.
I think it's NYT who a few years ago had a series of articles about the work of maintaining the underground aqueducts that bring water to NYC, and in building a new one. [1] It was to me a more engrossing read than any OS deep-dive article, despite the latter being more in-line with my passion and work.
It's also why I loved the fantasy book "Two Serpents Rise" [2] by Max Gladstone, because it's basically about the water infrastructure of Los Angeles. Which has a fascinating real-world history of its own! [3]
[1] can't find NYT, but here's a related article: http://www.theverge.com/2013/10/19/4853636/underground-with-...
[2] http://www.goodreads.com/book/show/16059411-two-serpents-ris...