If you're talking about memory leaks, then no, the effect will still be there in memory, even if you can't see it. You must remove it with the "DestroyEffect" function
If you're talking about the pretty effect model, yes, it'll go away when the model is removed. You can make it stay by using "Create special effect at point" instead of "... on unit".