The question is too general. I presume we're talking about copper pipes? If your water pipes are installed on exterior walls (bad idea) then you should insulate the wall on the cold side of the pipes. If they're in cantilevered joist spaces, insulate. If they're in other parts of the basement and the basement and the house above is properly heated there is no need to insulate your pipes to protect them from freezing.