Racism and race-related hate crime has increased since the 2016 Brexit referendum, with officers appointed to deal with resultant "tensions".