Manchester City to offer club legend Sergio Aguero ambassadorial role after retirement due to heart condition