Skyrim does a nice job with smoke and embers. This mod does an even better one. If you want those billowing campfire plumes to look denser, or the grain of smoldering wood to be more nuanced, this mod more than gets the job done.
Get it: Realistic Smoke and Embers