There is a command-line program for linux called "motion" that I have used with webcams before. I am not sure if it would be possible to port it to Maemo and get it to work with the N900's cameras.