Seven states, including California and Arizona, agreed to voluntarily cut their water use. But as the climate warms, any victory may be short-lived.