The Narrow Water Bridge linking Northern Ireland and the Republic will be a “symbol of hope”, an Irish minister has said.