The tap water in Chicago heats up as the lake heats up. I live in a building with a rooftop tank, but that doesn't seem to heat up too much, since water doesn't linger in that too long. I hear that Boston, despite using reservoir water, has cold tap water, perhaps traveling through tunnels cools it off?
Seems I've seen a movie with failing water tanks, can't remember what it was though, definitely a "B" movie or less though.