When I was in high school my best friend and I use to vacation in Branson. We took a scuba diving lesson there and made friends with the instructor. We were able to dive several times in the lake but it was merky and not like what you see on TV. 

One spring break with my family my brother and I had the chance to scuba dive in Cozumel. It was amazing!!! I definitely recommend it!