Not to sound wishy-washy but it all depends on time, money, and distance to travel. On the expensive side:golf locales that would not be too hot in August: Whistling Straits and Blackwolf Run in Wisconsin are fabulous. Bandon Dunes in Bandon, Oregon is phenominal. And of course Pebble Beach has mutlply courses and places to stay. However on the moderate side you can find great golf in the San Diego area as well as Colorado. If heat is not a problem then Phoenix, AZ, Austin, TX, and anywhere in Florida are great option.
Several Marriott Resorts have great golf courses and you can not go wrong with any of them. It would come down to climate in August. The Marriott Doral in Miami FL is a PGA course and has several courses. but to play the PGA courses it fairly expensive. As well as Ponte Vedra Fl, Sawgrass Resort. In the end though Hawaii if you have the time can't be beat.
Assuming you are leaving from Atlanta...and you want to stay at Marriotts...
1. No Flying: Drive to Hilton Head Island, Several Marriott choices, fantastic golf, nice beaches! Get him a round at Harbour Town and he'll be forever greatful! Or try Stone mountain right outside Atlanta to stay real close to home. The resort is nice and the golf course is decent.
2. Short Flight: Williamsburg, VA. Marriott's Manor Club at Ford Colony. Great place! Check out Kingsmill and Golden Horshoe golf courses.
3. Splurge Trip: JW Marriot resort in Las Vegas. About 15 minutes from the Strip. GREAT GOLF! and who knows...you could leave with a boyfriend and come back with a husband!