Well maybe not 100% seamless, but I do have a folder that is integrated into my file system just like any other file. I just have to type "svn up" in the command line and the folder is up to date. I am not sure what you mean past that, I could probably write a sub routine which would update type run svn up whenever I received the email telling me the svn had been updated which would make it 100% seamless. Maybe I don't understand your statement exactly.
Anyway, here is the book
http://svnbook.red-bean.com/ on how to set up these servers.