Even for RO the big expenses are running the pumps and fouling of the membrane, caused by high concentration of salt due to the high pressure used. If you weren't worried about throughput they last a very long time. You could use cheap electricity to pump water to a reservoir and use gravity as the pump for cheap RO. It isn't any different from any other source of off grid storage.