How do I make cool effects

Hey all, how do i make cool particle effects?

For an example. I would make a flaming scroll, if i pickup this i would have an flaming arrow and my characters hand are under fire or something.

I know where i can create the powerup but how do i make an cool effect?

Thanks =)

Here, I don't know if you mean something like this, but the fire effect is pretty cool

=>