A North Ayrshire councillor has been accused of an “astonishing” breach of ethics rules after backing a 100% tax on second homes.