[Python] Add nanoarrow integration test

[paleolimbot]

Describe the enhancement requested

As suggested in #39985 (comment) , now that nanoarrow has Python bindings, it would be beneficial for both pyarrow and nanoarrow to have a set of integration tests, perhaps as test_nanoarrow.py in python/pyarrow/tests. It might be a good idea for the in-progress Python interface to stabilize a little although the c_array(), c_schema(), and c_array_stream() constructors are all literal wrappers around the ABI-stable C structs and probably won't evolve much.

Component(s)

Python

[github-actions]

This issue has been marked as stale because it has had no activity in the past 365 days. Please remove the stale label or comment below, or this issue will be closed in 14 days. If this improvement is still desired but has no current owner, please add the 'Status: needs champion' label.

[thisisnic]

This issue has been closed because there has been no activity for the 14 days since the stale warning. Feel free to reopen if this has been closed in error.