Your writeup is a bit unclear, but if you are talking about shooting on film, transferring to video, and then doing all your post-production on video, I'd say that might be a waste of money.
Film, even 16mm, has very, very high resolution compared to home video, along with much greater color and contrast ranges than even the best digital video systems available today. If you shoot on film and then transfer to home video, you will be throwing away all that extra resolution, color, and constrast. It would be more economical to shoot on video.
On the other hand, originating on video makes movies look cheap. Even after images have been transferred to video, one can instantly recognize whether something was originally shot on film or on video. For that reason, much of what we see on prime-time TV is done using film. People have been socialized to think of the film look as professional, and used for fiction, while video is associated with reality shows, such as news, and with home video.
The differences between the film and video "looks" are due to many factors, including the way film and CCDs respond to light, but one of the most important is the frame rate. If you were to shoot on video at 24 fps, you will eliminate much, but not all, of the cheap, video look from your productions, while still keeping the economic advantages of video. There are video cameras, such as Sony and Panasonic's latest HDTV cameras, which can shoot at 24 fps. They are a bit expensive, but worth taking a look at.
As for editing and special effects software, Apple's Final Cut Pro is probably your best bet in terms of price/performance. At $995, it's not cheap, but it's certainly cheaper than some of the really expensive professional packages out there. For 3D animation, I'd suggest something like Electric Image or Lightwave.
Side note: if you are talking about transferring some old home movies that were shot on 8mm or 16mm, I'd say most definitely, do NOT throw away the film when you're done, for reasons stated above. If you're worried about scratches or dirt, try using FilmGuard (click on the link, then click on the word "Cleaning" in the bottom frame). It's amazing what a little cleaning fluid can do to keep film looking like brand new. Store it in the proverbial "cool, dry place", and it will last a long time -- longer than most digital media. (Remeber those stories on /. about how CDs, hard disks, backup tapes, and other media probably won't last more than 20 years?)
There are TONS of books, magazines, and websites out there with information on home movie making. Do a little reading and find out more.