could be as simple as an animated gif in some cases.
different frames (pictures) are created then assembled into a gif image by a photo program. photoshop is the standard for this but there other alternatives.
for the ultra realistic looking ones.. clouds could be created/rendered in programs like vue, aftereffects, etc. there are tutorials for creating such clouds. then, they could be animated and made into a gif format.