You are in for some great fishing. Although I am in Dallas, my brother lives in Alpharetta, GA and fishes Helen all the time. When I am over we do not stay there as the drive is short. Check out the Lodge at Smithgall Woods, which is where Duke's Creek is. http://www.smithgallwoods.com/
They are a little on the steep side and don't know about pets but they should be able to at least point you in the right direction. Good luck and good fishing.