[Python][Annotations] Add internal type system stubs (_types, error, _stubs_typing)

[rok]

Describe the enhancement requested

(2/9) To add type annotations to pyarrow and resolve #32609 we want to add internal type system stubs.

Component(s)

Python