Work to reorientate Cork city’s Kent Train Station to face the city is set to begin this summer after a multi-million transport funding package was announced.