Is there a freezing-water-resistant metal pipe?
A common device used in the US (and required by some building codes) is a water outlet that is long so that turning off the water allows the portion exposed to the elements to dry out.  These are called "Frost-free" or "freeze proof", etc.:



They come in different lengths, and the actual valve is all the way to the right of this picture where the copper meets the brass.  This causes the entire valve to drain so no water is exposed to outside temperatures.  The actual water pipes will be well inside the wall of the home and will generally not be exposed to freezing temperatures.

Here is another diagram to help explain from this answer: