>Of course building a tower capable of holding many tons of water is a comparably complex civil engineering task and is costly in materials.

In most cases it's not. You park a ground level tank on one of the taller hills in town.