We were there one year during the last of April first of May timeframe. Water was warmer than I expected. A couple of days though, the red warning sign was out, I think due to shark potential. Other days, there were quite a few people surfing, swimming, and wading.
The drive from Orlando really was not all that bad. Some airlines fly into Melbourne. But it's about 10-15 minutes from the resort into the town of VB.
VB Resort rents out water floats, chairs, umbrellas. But if you are going to be there for a while, it might be cheaper to buy stuff from Walmart.
There's a really good thread that circulated on here a couple of years ago about things to do in VB. I don't know how to do a search, but maybe someone can post a link to it for you.