Access to Cork’s main train station is to be reorientated to face the quays as part of a €8.3m investment in the city’s public transport network.