(docs) Clarify docs for the package type's source attribute

- "Local" means on the system being managed, not on the puppet master.
- Everything is provider-specific.
- Repo-based providers ignore source completely.