Captain Vincent Kompany leaves Manchester City to become player-manager at former club Anderlecht.