Rotherham Council will spend £25,000 on a study into the future of the Rotherham Civic Theatre.