You are definately talking about 3rd party programs like Adobe After Effects and, like Silverblade said, Particle Illusion.  It's gonna cost you money and time to master, but both will give you very good results.