Better User Activation lets you set a User Registration Activation page. Choose a page on your site and users will be automatically redirected to this page when they activate their accounts.