Huge investment in transport network ahead of Commonwealth Games 2022 will leave 'lasting legacy' for city, top bosses pledge