[Python] Expose CSV writer option `quoting_header`

[pitrou]

Describe the enhancement requested

This option was added on the C++ side in #47524, it should be exposed in PyArrow.

Original issue: #41239

Component(s)

Python

[susmnty]

hello am Priyansu, as am new in it the first contribution i want to do in this, if possible.

[pitrou]

Hi @susmnty feel free to try your hands on this and submit a PR.
(also, you can ask questions)

[ayushbansal07]

Hi @pitrou, this is my first time contributing to the project.
This issue seemed like a good place to start, I tried something and created a PR (not sure if I needed to inform here first).
Would be great if you could have a look and provide a feedback.

Thanks

[AlenkaF]

Issue resolved by pull request 47610
#47610