It doesn't sound like a good solution to me. We collect rainwater via a sediment trap and a particulate filter into a large (3,000 litre) underground storage tank. Because of the difference in levels (~600 ft) we don't pump water into the tank from the watercourse in the valley below, but we do have an extraction licence (or the equivalent) and we also are about to construct a borehole for water extraction. These water sources could be pumped to the tank if necessary, probably using solar or windpowered pumps.
Since the system has to cope with lavatory flushing, instead of installing a changeover as you appear to be thinking of, we use the other approach of having a float valve in he tank. When levels get very low (below a reserve of 50 litres or so) the valve admits mains water so that there's always something there to flush the lavatory. Simple, effective and as close to automatic as you can get.
At present "grey" water is passed through a degreasing trap then to an anaerobic filter and then into land drains. Howewer I intend to get the quality of the effluent water checked and if the quality is sufficiently high that will be returned to the storage tank for slushing and irrigation.
Anyroad up you won't read this, so it's your loss.