Attached Link: Smoke trail example

 Here's one I did with the particle generator (spheres) some time back. Animating the alpha with the Particle Shader function will provide you with a wide range of visibility options.

Sprites do a great job but aren't required. If you do use Sprites, increase the transparency value to something like 50 by typing directly into the value field instead of using the slider.