I have this setup for my RV.
I have a NC (normally closed) valve connected between my water line and the trailer. I also have another, of the same valve, attached at the low point drain.
U.S. Solid 3/4" Motorized Ball Valve 85-265V AC Stainless Steel Electrical Ball Valve, 2 Wire Auto Return Setup Normally Closed Amazon.com
I use a Wyze Outdoor Plug to control the power of each. I have the Wyze Home Monitoring setup with leak sensors at all potential leak points.
In the rules, I have it set so that if a leak sensor triggers, the incoming water valve is closed and the low point drain valve is opened for one minute, to relieve pressure.
This setup will also close the water valve during a power outage, but will reopen the valve when power comes back on, since the Outdoor Plug remembers the state.
FYI, this setup has already saved my trailer once when a connection under the kitchen sink loosened up.