Mean ergodicity and spectrum of the Cesàro operator on weighted $c_0$ spaces