A new €10m revamp to Cork city’s railway station is to open to tomorrow providing passenger access to the quays for the first time.