Firstly, it's not a good idea to give out your email address. The envelope at the side of your name can be used if you invite someone to email you. Also, use the 'Add response' below to reply to suggestions.
Basically, any new computer can do what you want. A 80GB hard drive should suffice to start with, you can add additional hard drives later if neccessary.
To catalogue the CDs seperately, you will need a program such as Excel, or Works Database. Most PCs have one of these pre-installed.
For the pictures, you will need a scanner.