The main problem with the stone stacks is that there's nothing holding the stack together, so in a good windstorm or earthquake, things could easily shift to the detriment of your structure. [Plus the stones should be partially buried in the soil, which is impossible to verify from the photos.]
And as to your original question, what you have isn't suitable for a water tank, but if you are interested in fixing your existing footings, the additional work for the water tank would likely just be two more footings and some framing. You'd want to get an engineer to design all that for you, rather than listen to some person on the Internet.
Cheers, Wayne