A borough author says he is "chuffed to bits" after being recognised with an MBE in the King's New Year Honours list