Channel 2's George Howell was on Lake Forest Circle, where Forsyth County dive teams recovered the man's body.
Firefighters said the middle-aged man was fishing in the small neighborhood lake when his kayak overturned and he drowned.
Roswell police said the lake was too deep for wading.
"A kayak is very hard to manuever, if you're not used to it. I don't know if this gentleman is used to the kayak or not, but apparently he did frequent the lake in a kayak and we do know that he did not have a life vest on," said Roswell police Chief Ricky Spencer.
Neighbors said they tried to save him, but they were unsuccessful.
"I thought it would be shallow enough that I could actually find someone and bring them to shore. I couldn't even touch the bottom. It was at least 20 feet deep," said Kevin Hamilton, who lives behind the private lake.
WSB-TV Kayaker Drowns Hamilton said he and a friend saw the victim struggling, so they tried to help.
"I dove and dove and dove and I could not get him. I could not find him," Hamilton said.