[3.14] GH-100108: Add async generators best practices section (GH-141885)

[3.14] GH-100108: Add async generators best practices section (GH-141885) #245465