Given the relatively short distance, any golf cart would really suffice. Everyone's made some good points though with regards to street legality (although I'm sure law enforcement wouldn't bother you for using it to and from the lake) If that's really a concern there are guides out there to help make golf carts street legal. I personally would recommend
Golf Cart Garage only because they have a ton of resources on all the things you are looking for...buying new vs used, making golf carts street legal, gas vs electric, etc.