You can disable the “User Activation Email” notification under Admin-->General Settings→ Email Notifications.