So this is possible....Devico retriever
http://www.devico.com/services/directional-core-drilling/
I think you can collect 11 metres at a time.
or try
http://www.devico.com
Not sure how far you can go
One big advantage...drilling under the lake instead of through it....going through requires cementation ! Other wise water will find a way in when you mine.
Good luck