It's probably easier to replace pipes in an older European house anyway; less insulation / less layered walls, less things embedded in concrete, sometimes even wood beam floors. I lived in a >100 year old house that was renovated at some point, newer pipes and electricity was put up against the walls, then a layer of drywall was applied everywhere to make things look tidy.
Another way is to put the valve below the freeze line in the ground. Opening the valve to the water would close a drain valve in the pipe leading from it to the faucet, and closing the valve would open the drain valve.
I have a setup like this at my house, although the two valves are not linked. It works fine.
Otherwise you’re just building a house around your outside pipes.
No amount of insulation is going to help your pipes outside overnight under a certain temperature. The water isn’t moving because you aren’t using any of it.
We had some pipes inside under the floor of an old addition of an older farmhouse which regularly froze despite being inside, our wellhouse had hundreds of watts of heating. There’s no chance of pipes exposed outside in a northern US climate not freezing.
Keyword is "self-regulating pipe heating cable".
I don't know why you're making it out like it's rocket science and with such confidence.
Does it not freeze in Europe? If they did that in Flint the pipes would freeze in the winter.