An anti-smoking advert in the US featuring the sound of farting cows has been taken off the air after complaints.