Water demands continue to inch up year after year even as climate change queers supply. Can civilization cope? David Biello reports