This is an old southern term used by my grandmother. It is a disrespectful term for a white person similar to "cracker" or "honky." I believe it comes from the fact that woodpeckers have reddish hair up top like white people.