Superdrive equipped Macs come with iDVD. The older version (Pre iLife '04) will install automatically with Mac OS X if it detects a SuperDrive during the install process.
If you missed out, you can purchase iLife '04, which includes iDVD. This current version does not require a SuperDrive, or indeed any DVD-Writer, to function.