Northern Ireland could be used to smuggle illegal drugs and weapons from the EU into Great Britain after Brexit, police have warned.