Last decade saw several states experience severe water shortages, triggering periodic restrictions on usage and even forcing some communities to import bottled water for drinking