Cardiff's long-awaited new bus station officially opens on Sunday after years of delays.