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.  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"  by Max Gladstone, because it's basically about the water infrastructure of Los Angeles. Which has a fascinating real-world history of its own! 
 can't find NYT, but here's a related article: http://www.theverge.com/2013/10/19/4853636/underground-with-...
I specialize in water, so getting access to the treatment plans is my favorite. Drinking water plants are mostly off limits for the public but I've gotten tours of a few.
If you're around the NYC area try visiting the Brooklyn Wastewater Treatment Plant. Those egg shaped digesters are really well designed. I even heard of a couple getting married there.
Two of my favorite books:
The Works: Anatomy of a City https://www.amazon.com/Works-Anatomy-City-Kate-Ascher/dp/159...
What Do People Do All Day https://www.amazon.com/Richard-Scarrys-What-People-World/dp/...
I wish Amazon would show a few random pages from the middle--the actual content of the book--so we can see what we're going to be reading. It seems like common sense.
If a library is nearby, you could look at it there, or even check it out: http://www.worldcat.org/title/works-anatomy-of-a-city/
e.g. her papers from the 90s
Steps Toward an Ecology of Infrastructure: Design and Access for Large Information Spaces
The Ethnography of Infrastructure
On the same topic, another inspiration for fiction is the book Cadillac Desert by Marc Reisner: