Download StylizedFog FREE Unity. 

It allows you to create colorful animated fog effect easily and artist-friendly!

Use the custom editor to edit your fog color ramp directly in unity without having to do back and forth with a third party 2D software.