So, that leaves me with some kind of water tank.

A holding tank in the attic would not work very well either, as our well
feeds multiple buildings.

I don't understand why that matters.