I work in 911 dispatch, something like this hasn’t happened in my county while I’ve been working here, but we do have at least one interesting water situation that I’m aware of
We border a major city, but the far end of our county is fairly rural, I still consider it to be suburban but just barely, go much further and you start hearing banjo music.
The fire departments in the city are of course heavily focused on urban firefighting and rely on hydrants pretty heavily because they’re all over the place.
Once in a while though, they get a big fire in less built-up places where they don’t have adequate hydrants, the one that comes to mind was in a large rail yard towards the outskirts of the city.
So they end up needing to call in for mutual aid from us and other surrounding counties to send in pump trucks and such that can pull from a nearby river or what have you, and our more rural areas do that all the time because we have a ton of rivers and streams that run through our area and hydrants can get a little sparse in areas, so we sometimes end up sending them an hour or so down to the city to help with a fire.
They also have, what a lot of them call artificial ponds, though I suspect they have a more official technical term, which is sort of like a portable swimming pool they’ll sometimes set up at the fire when there’s no other convenient water source. They’ll dump a truck load of water into it then send the truck to go refill wherever they’re able to, often with a few trucks making rounds doing this.
Tangentially related, the town I grew up in once upon a time had a lot of factories and mills. One of the biggest factories had a house just a short ways up the hill from it that had a large swimming pool, I believe the house belonged to the owner’s son in law or something. Apparently that swimming pool was rigged up to work as a backup water supply for the factory’s sprinkle system.
That factory was long closed and converted into offices by the time I was born, and that swimming pool was no more. It’s one of those things that’s only been passed on by word of mouth by people who used to work in that factory like my dad, so it is possibly apocryphal.