right I am eventually hoping for the devs to make or a mod to create basically underground water veins or lakes- similar to finding a huge pile of ores- and you could build something like this (assuming the building AI worked well enough).
A cistern, or silo, would be very different and a lot more complicated as it relies on specific water simulation. I talk about it a little bit in one of those thread linked above…
Here is a picture of an ancient cistern discovered that is the size of two football fields so that the city was able to survive a lengthy seige.
http://www.messagetoeagle.com/wp-content/uploads/2015/07/basilicacistern5.jpg
Apparently there is a documentary on the subject if you are interested here it is
https://www.youtube.com/watch?v=o74i8hPN3fc