Support CSV files encoded with charsets other than UTF-8

[Rafferty97]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.
It seems that CSV files encoded with non-UTF-8 charsets, such as Windows-1252, are annoyingly common in the wild. It would be useful to be able to consume them directly via an additional configuration option.

Describe the solution you'd like
Add a configuration option to the CSV reader to specify a character encoding, defaulting to UTF-8. The implementation can make us of encoding_rs, and could be feature-gated so as to not affect users who don't need this functionality.

Describe alternatives you've considered
The only alternative I can think of is to decode the entire CSV file up front before reading it via Apache Arrow, but this is suboptimal for a lot of usecases.

Additional context
I originally opened a similar issue in the Datafusion project, but after further reflection, figured it was possibly better implemented in Arrow itself.

[brunal]

I think this can be achieved without any arrow change, using encoding_rs_* streaming encoders/decoders.

// Basic
fn read_utf8(filename: &str, schema: SchemaRef) -> RecordBatch {
    let file = File::open(filename).unwrap();
    let mut csv = ReaderBuilder::new(Arc::new(schema)).build(file).unwrap();
    let batch = csv.next().unwrap().unwrap();
    batch
}

// With a different encoding
fn read_other_encoding(filename: &str, schema: SchemaRef, encoding: &encoding_rs::Encoding) -> RecordBatch {
    let file = File::open(filename).unwrap();
    let mut decoded = encoding_rs_rw::DecodingReader(file, encoding.new_decoder());
    let mut csv = ReaderBuilder::new(Arc::new(schema)).build(decoded).unwrap();
    let batch = csv.next().unwrap().unwrap();
    batch
}
```

The change is minimal and doesn't require upfront decoding of the whole file. I believe that's a better solution than adding a crate feature (I don't like crate features) & another dependency.

[alamb]

label_issue.py automatically added labels {'arrow'} from #9468