[Python] Better pytest parametrization for different compression codecs

[asfimport]

Follow-up for #10717

Certain codecs are optional, we should have global pytest fixtures automatically applying the right pytest markers.

Reporter: Krisztian Szucs / @kszucs

_{Note: This issue was originally created as ARROW-13380. Please see the migration documentation for further details.}

[sahitya-pavurala]

take