AI Solutions for Climate-Driven Water Issues