I don't know about the Yukon, but I grew up in northern Saskatchewan (which is definitely "up there") and we had well water. Generally you have to dig the pipes into the group so they are laid in the perma-frost and don't have issues with freezing in the winter. (yes when i moved down to DC most people had never heard the word "perma-frost" before )

If the water tank is not kept in the basement of the house, it will be insulated so that it doesn't freeze (kind of like a giant hot water heater blanket).

But congratulations on getting water!