Doug & Amber,
We live in northern Michigan and like to camp in the shoulder seasons. Nothing like the camping in the fall in northern Michigan (although it is snowing tonight).
We had concerns with the water system too, when it dipped below freezing. This was one of the questions that we had at orientation.
Cary told us the most vulnerable area to freezing is the faucet and sprayer. He suggested that we turn off the pump, we open the faucet and move the nozzle up and down until all the water drains. Then pull the sprayer hose out, over the counter, and hold it low and turn on the sprayer until all water drips out of it.
This does a couple of things it removes water from the most vulnerable area and gives any remaining water a place to expand.
I would think the next area of concern would be the hose between the tank and the pump. That is in the storage area so typically there are things around it that will hold the warmer temperature of the day time for a longer period of time.
The tanks being a larger body of water would take longer to freeze.
All of this would depend on how cold it gets at night, how warm during the day, and how long it stays below freezing. Mid 20's at night and 40's during the day, what I have suggested has worked for us. Longer than that I would suggest a different source for fresh water and if using the gray water tank, I'd have some anti-freeze in it.