The RAF veteran and former police officer had been a councillor since 2016