You can either upgrade or do a clean install. Upgrade works perfectly, normally they go on smoothly without causing any problems.
And if you make a clean install, of Leopard, then Leopard won't have the iLife apps. So after making the clean install of Leopard, insert the second DVD of Tiger to install the iLife apps.