Multiple layers of Fractal Noise. All you are ever gonna need.
Check out the 4 part tutorial on the cathedral. Part 3 has a section on creating fog. Not a lot, but it will give you the basic idea. I will add the link to part 3 below - though i do suggest running through all 4 parts if you have the time.