Add guidance for adding new dialects and integrations (CONTRIBUTING.md)

[mfridman]

Although there are established patterns in the code base for adding/modifying existing dialects, it'd benefit if we had a blurb or two on how to go about this. Kind of like a checklist.