[SPARK-3054][STREAMING] Add unit tests for Spark Sink.

This patch adds unit tests for Spark Sink.

It also removes the private[flume] for Spark Sink,
since the sink is instantiated from Flume configuration (looks like this is ignored by reflection which is used by
Flume, but we should still remove it anyway).
Maybe keep the naming consistent. If this is called "Success Test", then name the next ones as "Failure Test" and "Timeout Test". You can even remove the "Test"