Spurs star unlikely to play for club again after agreeing move elsewhere