Sporting's Hugo Viana is set to replace Txiki Begiristain as Manchester City's director of football at the end of the current campaign.