To turn off this sign up email from being sent to the requesters, please go to Admin --> Workflows --> Email Notifications --> Requestor notifications and turn off User activation email.