Award-winning editor axed after six years in charge of hometown weekly Hundreds wish news chief well as he departs paper