Northern Ireland's chief civil servant has warned a no-deal Brexit could have "grave" consequences for the region.