Well
Wells are a primary industry which can generate water directly from the ground.
Over time active wells will exhaust the water in the ground, and across long periods a city would need to close down old wells and open new ones in areas with fresh water to be extracted.
Water is primarily used as a drink.