A phalanx of former players were in attendance as an emotional Pep Guardiola was honoured with having the north stand named after him