Two types of fog one that covers the ground and one that fills a area. Use post magic plugin with a little bloom to make it a little glowy. Multiple colors for each type.
I was looking for something exactly like this when I was putting together the Rain effects package for my scene. They work so well together, thank you!