AI Water Risk Management: Acting Before the Drought Hits