Cavity Optomechanics for Hybrid Quantum Systems