What does the "Stationery Pad" option do?

Basically, it tells an app opening the file to open a copy.

You do this on files that you want to use like templates. Since the app is given a copy, you'll never accidentally change the original.
Basically, it automatically copies the file into its original location (as 'name copy') and lets you work on the copy.