[saltman]

Go with Sony Vegas Video 6b. It's very easy to use. Premiere is another good choice. Stay away from Pinnacle like the plague.

Your gonna need an authoring program when your done to put it on DVD. Go with Sony DVD Architect 3B. Easy to use and seamless with Vegas. I personally don't like Adobe Encore.... but others seem to like it. Encore is more customizable but much more difficult to use for a beginner.

Your also gonna need to do some research into how to get it from what format it's in to one you can use in any of the programs above. For instance if it's on DVD already. You might look into something that demultiplexes so that you don't have to reencode twice. If it's a VHS there are other scenarios.

Good Luck