This is mostly what Carousel does. The photos are all stored in Dropbox. What it doesn't do is your #2, which is to automatically delete the photos from your local device after a period of time. You can do this safely yourself, though, since the files are all stored in Dropbox.