Recorded drug crime is increasing in many small towns and villages even as it falls significantly in city centres, analysis by the BBC finds.