A council is to exploit a city as a magnet for production crews with the establishment of a dedicated film office.