Brillouin cavity optomechanics: Single-quantum-level operations towards quantum memory applications