Household water costs could nearly double in some American cities, new research suggests, as climate change further stresses municipal water systems.