City finally have their dream manager but Pep Guardiola has a lot of work to do to get his squad challenging at home and in the Champions League