SNOW-1564550: Local testing environment

Hi. The snowpark-python SDK has support for a [local testing environment](https://docs.snowflake.com/en/developer-guide/snowpark/python/testing-locally) which greatly improves developer experience for writing unit/integration tests. It would be nice if the scala-java SDK could offer a similar support.