The charismatic manager has confirmed he will take up a new role with the franchise in the new year