Never give up!
First and foremost, try to be calm and confident around your dog. Hide your frustration and anxiety.
When visitors come to your house, try putting Scrappy on a leash. Leaving the dog on the floor or ground is always best. When he does something undesirable, tug the leash and say "Uh uh uh."
Try some calming music. I recently purchased "Through a Dog's Ear" and it is very relaxing for my boys.
Try wearing out your dog physically with plenty of exercise, and mentally with challenges such as trick training.
Give your dog a relaxing massage daily, or twice daily.
Take your dog places and challenge him. My older boy gets restless when life becomes routine and predictable. He requires lots of interaction outside of his territory (neighborhood). It is a daily challenge. He is not hyper, but he wants to get out and do things.
Meet with a training and behavior expert. Go back to obedience classes. I'm looking into classes right now for socialization and to give my guys some activity.
Hang in there. Don't give up.