The Sky Blues have opted or a big name with the appointment of Frank Lampard as their new head coach