Refactor cross-module provider organization

[nikkelma]

According to terraform module provider best practices, providers should only appear in root modules, be passed explicitly into child modules, and should specify provider requirements in a terraform block.