Blender Cloud texture settings: How to get from 0 alpha partial transparency in render?
You can use the Value from the cloud texture to get transparency.
Enable nodes, and in material nodes connect the value of the cloud texture to the Output's Alpha.
You can fine tune the amount of transparency by adding a color ramp in between .