Councillor accused of undermining confidence in vaccine programme says he is 'leading by example' after taking the jab