I like
coppermine for an online gallery. It is an opensource php/mySQL package.
You will need to modify it significantly to get it to do what you want. I can't imagine such a package that will do all you want without being modified. You said you weren't a programmer...well it's time to learn (or shell out the bucks for someone to do it for you).
If you do choose to go with a CMS, you can use
PHPNuke. There are a few ways to incorporate coppermine with nuke,
here is one example.
Good luck.