Manchester City have agreed a deal for Sporting's Hugo Viana to take over from Txiki Begiristain as a new era dawns at the Etihad Stadium.