Well, speaking as a graphic designer with over 20 years of experience, the question is kinda like asking, "All I want to do is play Dust in the Wind," but you don't know how to play guitar.
Not dissing you, just explaining that it's a little more complicated.
How are you having you CD covers printed? Through a local printer, someone online, through someone like DiscMakers?
Do you understand the difference between CMYK and RGB?
Do you know what the proper dpi is for the line screen you'll be using?
Have you considered just saving yourself a lot of grief and hiring either a local graphic designer or someone from online, like elance? (you can find people there that take on projects relatively inexpensively). They can set the project up for you so it correctly works with whomever you chose to print it.
But, to answer your question: I use a combination of (Adobe) InDesign, Illustrator, Photoshop and Acrobat (mainly for compressing my final files to go to the printer). As for fonts, I only use Adobe Type 1 (never TrueType) to go to printers.
Hope that helps.