Hi Chris,
The options fall into Direct mechanical and indirect mechanical with digital options.
Direct Mechanical is where you mount the turret onto a servo in some way and this turns the turret within the limits of the servo* You can use a stepper motor in the same way using a computer or ESC control.
Indirect Mechanical is where you either use two gears, one on the servo/motor and a larger gear on the turret, or you use a belt or cable and pulleys. The latter can be used to control a number of turrets at once, but you have to make sure they do not revolve too much and hit superstructure or other turrets.
Digital control using say Arduino or Raspberry Pi mini computers allows you to use stepper motors and program speed of rotation and traverse limits.
Have a look at Battleship builds especially those by Geoff (HMS Iron Duke, Invincible etc) and also there is a build log here of HMS Rodney by C3PO
HMS Rodney (modelboatmayhem.co.uk)A lovely chap called Bob K was/is working on a model of HMS Agincourt and he did lots of development along side Geoff and C3PO. I recall stepper motors being involved.