Hi!
Before I begin, I'd just like to point out that I am not much of an expert in programming nor am I in matters related to water related issues in reality and history. I am though, a big fan of the Civilization franchise and any ideas that could improve/benefit it I support willingly and I see potential in this idea put forward. I donot think my thoughts would have much impact on the game's final release but such is the way of things, but I'll voice them anyway.
Civilization is already such a complex game with many rules. Although its not a necessity to learn every single rule to play the game and have fun, it is beneficial to the player to understand these fundamental principles in order to maximize the gaming experience. From reading the many threads in this amazing forum, I can see many have gone through a lot of trouble in finding the specifics to many unexplained game mechanics. This idea of fresh water being a finite resource should not complicate it any further.
The problem with the way water is implemented in the game is NOT in the food/production/commerce bonuses it gives nor is it the improvements that directly or indirectly connects to it. In fact, I believe someone here has already made a very good point about it (see 1st quote below). As some of you have mentioned (and I completely agree) is how irrigation works prior to researching the TECH advancement allowing workers (settlers in previous Civ games) to irrigate without nearby fresh water (rivers, lakes, etc.). The problems lies where ONE fresh water tile can be used to irrigate unlimited number of terrain tiles (ones that can be irrigated). In the early stages of the game, once you have found fresh water (i.e. a tile with a river), you can create an irrigation chain that has no limits. In fact, ONE tile with a river is enough to support all available tiles that can be irrigated, therefore the whole world can have fresh water just from that single fresh water source, which is ridiculous. I know this is a very, very, very improbable scenario but it is NOT impossible. Can you just imagine all the civilizations sharing that one tile with a river? Not a very likely scenario I know but its there none-the-less. I believe this should be addressed in following "Civilization" incarnations, whether it be Civ4 or anything else down the track (I can wish, can't I?

).
I believe their is a good solution put forward here already (see 2nd quote below)
The original proposal, I must agree with everyone, that it is too complex. This "finite fresh water resource" idea, in my eyes, has merit. It just needs a way for it to be implemented into the Civilization game mechanics, as simple as possible, without breaking it, so to speak.
Another idea I would like to put forth is having certain improvements that is linked to "water" (aqueduct is the only one that comes to mind

) have prerequisites to building it. The prerequisite I propose is to have an irrigated square within the city's radius before it could be built, much like the "Hoover Dam" wonder requiring a river, I believe, within the city's radius.
BTW, I'm new to this forum so let me know if you find something I shouldn't be doing so I donot repeat it in future
-Pacifist-
The Peaceful Civ Gamer, who wants every city in his empire to have every possible improvement and wonders
Kurioku said:
Perhaps to simulate this aesthetic, a river tile in reference to city building and provison may supply x amount of utilization perturn. Though I think, after the balance sphere of the game, this is already implemented as food, commerce and production output. The ability to supply vast reaches of demand simply illustrates societies ability to improvise new technology and methods for supplimenting greater demand via improvements. which in turn means nothing really needs to be changed here, unless you want many other areas of gameplay affected on account that the balance will need shifting to adjust to this proposal of input
Texan General said:
You could, I suppose, create a maximum radius that water could be brought out from its source. For example, I have a river with a city 7 spaces away. The maximum distance I can irrigate out to with my current technology is 3 spaces. That means I cannot irrigate into the city's radius currently but 10 turns down the road when I discover <insert water tech name here> I can get water out to a distance of 8 spaces so my city has water. This would keep cities in the early game near sources of water (Historically accurate!) but in the later game as technology becomes better we could be building in deserts (like Las Vegas)