Allow state access in authorizations

[anilcse]

ref #8462 (comment) #8462 (comment)
While implementing VoteAuthorization as part of #8312, we needed access to the state to verify ProposalType against authorized ProposalTypes. For now there's no clean way to access the state (read-only should suffice) and validate certain authorization constraints. This will limit the granular authorizations and forces everyone to use just GenericAuthorization without any Msg specific limitations.
Allowing a way to read the state from authorization (inside Accept) would enable more freedom for users to make granular authorizations.

[aaronc]

Enabling at least the query part of ADR 033 seems like a clean way to address this.

[tac0turtle]

after discussions with the security team we have opted to create an authorization account type via accounts. Users can extend the account whichever way they would like without needing to fork as well. No need to modify authz further