Q: We would like to be able to tag, store, and search photographs in a central repository selected internal folks can access for publications, multimedia presentations, web pages, etc. We are talking about more than 500 photos but less than 5,000. We don't wish to sell any to parents, just access them internally.
A: Look into the php based Gallery program http://gallery.menalto.com/ I've run it on an Xserve with out any problems. It support IPTC caption data which lets you embed captions and other information inside the photo which is really handy.