There is no specific role that enables the execution of stored procedure, even if the user has rights to do whatever the proc does.
You will have to manually grant execute on the stored proc to the user(s).
Another approach is to create a custome role, grant execute on all stored procedures to that role and then add users into the role.