Two Photo Streams, one iPhoto library My wife and I share the same iPhoto library, which exists on a mounted disk image with each of our user accounts pointing to this same shared library.

We each have iPhones and I wondered whether our respective photo-streams that seemed to work reasonably well on our individual logins could be 'automated' to copy from these streams into the main, shared library?

Essentially, is there any way for two photo-streams from two users to end up in this shared iPhoto library?
To solve the problem you state, Dropbox would allow you to upload all the photos from two devices to one account (or two accounts) and then set up folder actions on a Mac to combine, import and delete the photos from the dropbox storage.

There isn't any "mix these two" photostreams function in iPhoto or Aperture and the web interface doesn't have any functionality to match that as well.

There is a way to push photos (manually) to a shared photo stream, and then both of you would see the same content in that stream, but it's designed for one person to push - not for several to collaborate and publish together.

The pragmatic solution is to set a calendar reminder once a month for both of you to export the pictures. I let iPhoto automatically import all pictures from my Photo Stream and it conveniently makes a November 2012 Photo Stream event and I export those original photos to my archive drive that sits on a shelf other than when it's time to archive. Rather than archiving (or perhaps in addition to), you would then do the steps needed to export and import the batch of photos into the library you chose to contain both pictures.

This both isn't automatic and also means that photos will be potentially duplicated if the library holding the merged content is different than the library that received the stream from iCloud.