A £550m cross-border investment deal will deliver a more reliable and comfortable rail service between Belfast and Dublin, operators have said.