The NFL legend is set to return to the sideline, signing for North Carolina, a team his dad previously coached