An A-B 700-HL Interposing relay only draws 0.3 watts at 120 VAC and can be held on (energized) indefinitely. No problem handling a 12V or 24V DC solenoid valve running from a backup battery. The relay itself is about twice the size of my thumb nail and about 3/16" thick. I use quite a few of these that are continuously energized in factories and infrastructure, and never heard of a problem.
Now that sounds like what I'm envisioning. I like that scenario.