The former Tide signal caller turned to the legendary Nick Saban for advice on his final decision