Its important that you first make a concept how your fireball should look like and behave. You'll achieve nothing without a basic concept. Then realize the concept with a combination of sprites and particles. Thats how fireballs are normally made in all games. Also look at other peoples effects, like here:

http://www.opserver.de/ubb7/ubbthreads.php?ubb=showflat&Number=320507