Substitute Sergio Aguero proved Manchester City's hero as they overcame Burnley in a tense 2-1 victory at the Etihad Stadium, despite playing almost an hour with 10 men.