Scotland needs a Good Friday Agreement-style mechanism to trigger an independence referendum, says Holyrood minister