Are you thinking Grid down or now?
I'm not sure to whom you are addressing this question, so:
Do it now, as soon as you can afford it.
Design the power system to use both grid power and local power (solar panels, etc.). That means DC pump motors which can run off battery banks. Try to avoid using AC pumps because the efficiency of the inverter will cause your battery system to work much harder (shorten lifetime).
The large water tank with a smaller pressure tank (pqtb suggestion) is doable now. You don't need a large pressure tank, 5 to 10 gallons is fine for household usage. If you must run water to the garden, then look at a gravity feed tank (on a small tower) which doesn't need power to push the water through hosing.
You only need power when you pump water INTO the tank, preferably done during the time you normally don't use the battery system. For instance at night, or when you're doing something else.
Try not to put heavy drain on the battery system during the charge cycle (when the sun is best on the panels).
Ok, information overload yet?