It's actually done in 2fort, but you don't notice because valve used func_rotating for it and then apparently broke it.
What you want to do is have a rotating object in the center, then have func_brushes textured with a cloud texture (there are one or two). Check the skybox of 2fort to see what I mean.