For raccoons, it would be better to have a professional come in and remove the animal. Raccoons are a rabies prone species in Georgia and it is never a good idea to mess with one. In order to keep this situation from occuring again, it is important that the entryway to the space be identified and fixed. If this is not done, then there's a very good chance that you will find creatures in your attic again. Habitats are becoming rare and opportunistic animals will take advantage of any space available, including ones shared with humans.
Woodpeckers make holes in houses for two basic reasons.
One is to make a nesting hole for himself, the other is to find food. Providing a woodpecker house for the bird would give it another place to make his nest. Place the house on a tree fairly high up and close to where the bird is making the hole in the house. Hang strips of yellow fabric or aluminum pie pans in the area where the bird is pecking or gently spray it with water when you see it pecking. This should help deter him from pecking there and encourage him to use the nest box.