An SNP councillor has resigned from the party claiming “government policy is being made with little or no understanding of the challenges remote rural communities face”.