An SNP councillor has been accused of threatening to use his party contacts against a drugs charity after he was asked to leave a media event.