Expand contribution guidelines for snowflake

We're getting more contributors to the project, we should expand CONTRIBUTING.md with some more basic guidelines like

• formatting of commit messages
• creating tickets for each pull request
• make sure the changes in the commit adhere to the commit message and the corresponding ticket