GH-41011: [C++] Add an output type resolver for decimal types in CompareFunction so can be casted correctly

GH-41011: [C++] Add an output type resolver for decimal types in CompareFunction so can be casted correctly #56640