We are going away just for the weekend in June we want to try out scuba diving we do not know where to go?

It is just a mini vacation we live in Upstate New York I would like to not go any farther then six hours away. We want to do something different sense we are getting rid of the kids for the weekend my boyfriend stated he would like to try scuba diving which I was game for but I am having a problem finding a place to go where we can enjoy ourselfs and they let us go scuba diving with everything we need to learn Please any suggestion