Hi, Ranger SVO points out Nero Vision that is OK I have used that in the past and it is easy enough.
Depends a bit on how far you want to go and how much time you want to spend on it.
If you want to go the whole hog than "Pro Show Gold" by
Photodex is my tip I use it and I like it very much, very time consuming though, but you can make a real show with titles, transitions, zoom in or out, audio sinc, digital quality, set for wide screen TV great range of options but not free, 30 day trail is offered well worth a try IMHO.
Naturally you will not get as many pics on the DVD as you would by just transferring them as you can with Googles Picasa 2 great free program for storing and managing photos. Other thing with Pro Show Gold is, it is a bit slow in rendering how slow depends on your system 1 Gig of Ram
would have to be the minimum.