No, the water pipes aren't likely to freeze. However' the water inside the pipes will begin to freeze if the temperature drops to, or below, zero degrees celcius. If the water freezes completely, as in "frozen solid" it will indeed burst the pipes. If, however, the water only partially freezes, it will turn to a consistency of "slush" that will be less likely to flow as would otherwise be expected.