A Syrian honorary consul in the US has resigned in protest after last week's killings in Houla, where more than 100 people were slaughtered in a massacre blamed on pro-government forces.