Coventry City have officially announced their new manager - with legendary former player Frank Lampard joining the club on a two-and-a-half year contract.