Ty for a question. You have an excellent eye for detail. Detailing makes every render and every project more realistic and more believable.

Axemaker and I are working on all our projects as equal partners and my job is to make our product presentations as best as possible.

Depending on what you need for your project there are two ways to make this effect.

1. You can use products like volumetric explosions, fireballs, or volumetric dust and scale and set it up in your scene. With some creative thinking and use of color, blur, and granulating effects you can simulate a fireball into sub water sand cloud.

2. You can use Photoshop for post-production of your render and with some cut-paste, drawing and shading you can create and add any detail you can imagine.

In this case, post-production was the answer.