Do you mean the cold water storage cistern or the feed and expansion cistern? One is usually big the other one much smaller. If it is turning to steam you could have a major safety problem on your hands.
Basically the water storage tank, heating comes on heats up the water in the tank which I think is then causing condensation to form in the pipe that comes out of the wall of my house that then causes a constant drip. Just wanted to know if I can do anything to stop the constant dripping?
I think you are on the wrong track. It's not likely to be condensation ,but the water level in the cold water storage tank rising to overflow level. Check the level in the tank. There can be a number of reasons the level gets too high.