A Brexit deal which is seen to threaten the union between Britain and Northern Ireland could lead to civil disorder by loyalists, the head of the Police Service of Northern Ireland has warned.