New adult entertainment services including sex shops will be banned from operating in prominent locations across the Adelaide CBD and North Adelaide, but existing venues will be able to remain.