VisualStudio.Net itself offers many deployment solutions.
Other obvious third party product is InstallShield.
If you are creating applications in microsoft technologies than I would recommend you to use Visual InterDev. It is based on windows installer and really gr8 and easy tool to build deployment solutions.