Since this is fantasy, the idea of flash drought popped into my headFloods. Especially flash floods.
Oh, yeah - throw in magic and you can get some really crazy things - appeasing/dealing with water elementals, raise/lower water magically, parting water, transforming it (to wine or blood?) redirecting or stopping flow, troll bridges, tortle enclaves, sahaugin raiders, river mounts, kelpie or nymph abductions, fossergrims and their waterfalls, draughs (drowned zombies) and all sorts of other obstacles and encounters.Since this is fantasy, the idea of flash drought popped into my head
Minneapolis and St. Paul exist as two separate cities because St. Paul was the uppermost site on the Mississippi for a river port due to a gap in the bluffs. Between Minneapolis and St. Paul the Mississippi runs through a 100-foot-deep gorge that was once filled with churning rapids that ended at a pair of massive waterfalls. (The rapids were later submerged beneath a dam that powered a now-gone Ford factory, the dam remains).The city might be just below a cataract, where you have to unload and portage cargo around the rough stretch anyways. Smaller boats can (carefully) ride the flow downstream but, betwixt rocks and current, you cannot get upstream. See also Louisville on the Falls of the Ohio.

(Dungeons & Dragons)
Rulebook featuring "high magic" options, including a host of new spells.