Mumbai reels under floods, while the prospect of drought looms large elsewhere. Water management needs to evolve