Ryder Cup Captain Paul McGinley is to become a Sky Sports ambassador and join the on-air commentary team.