A proposed McDonald’s restaurant that sparked outrage and pushback in a Wiltshire village is not going to go ahead.