You do not have to be in the middle of nowhere to have issues with water. The last time I visited the Cutbank campground in Glacier National Park, the water had been shut off for a couple of years. I visited another campground in Canyonlands NP and even at the end of September the water had been shut off until next season. At Great Basin NP, the water system was shut off due to some sort of emergency repair. All of that happened on the same camping trip.
Addendum: Oops I forgot about Mesa Verde NP. Campground was still open and due to close for the season in another week. Water was shut off.