A training hub designed to boost skills in the automotive sector will receive £9.7m in public funding.