Politicians and campaigners should take care not to “inflame” tensions around Brexit, a police chief says.