You can do a rudimentary password protection on a single folder by attaching a folder action that requests the password in a dialog, and if it's not correct, then it closes the window. That can still pose a security risk since they can see what's inside, but they can't access it.
The only other (major ) problem is that this doesn't work with column view or list view -- only icon view. So much for that.