What types of PDF creation software can I use to produce the PDF files that will be accepted by the USPTO?

The most common versions of commercial PDF creation software will be accepted by EFS-Web:

USPTO supports PDF standards versions 1.1 to 1.6, and Adobe Acrobat Reader 7.0.8 or 7.0.9 ONLY to use EFS Fillable forms. A detailed listing of PDF guidelines may be found at the EFS Forms page.
USPTO FAQ - Questions and Answers (24FEB2007)