The executive mayor blamed drought but water experts say the city’s reservoir levels are ‘leaking to critical thresholds’