A museum is to be built in Cork to recognise the achievements of Irish people who fought with foreign armies.