Guardiola farewell spoiled as Aston Villa beat Man City on final day