My first southerly vacation i had an odd experience, the cold water wasnt so cold it hurt your teeth. it was almost room temp. Weird.
mind you, water lines here are typically buried 6 feet, to be below the frost line.
Our water supply here comes from large above ground tanks just 1/4 mike from the house. In Summer, the tap water is close to the average daytime temperature. In Winter, it is close to freezing temps.
We save a lot on water heating in Summer, but in Winter a hot shower means turning the faucet to 80% hot water and it doesn’t last long.
Of course, in Winter a glass of cold water is just a turn of the faucet away.