A parish councillor resigned after distressing footage showed a cat seemingly targeted with an explosive left on a bird table in his garden.