Thank You :-)
P.S: What is the weather like around that date and good Restaurants and if possible night clubs that plays Hip Hop/ Pop songs only ?
If you want walking distance, you have to go with a Cedar Point hotel on site. Doing so has it's merits, such as cheap package tickets and early entry, but it will cost a little more. Personally, I always stay at a park hotel if my visit is extended. With the size of your party, I would look at either Sandcastle Suites or Hotel Breakers. If you are willing to sacrifice the walking distance to save some money, I would recommend the Breakers Express on the mainland. It's still a Cedar Point hotel with all the perks and it's just across the causeway.
A good thing about Cedar Point is that they do have other things to do on the island besides the park. They don't have a dance club that I know about, but the beach outside the Breakers will likely be hopping. I wouldn't be surprised if there was some kind of dance party on certain days in the evening. There are good restaurants outside the park on the island as well. Famous Dave's BBQ and TGI Fridays are both there, as are the Bay Harbor Inn (seafood, steak), and the Breakwater Cafe (diner food..decent breakfast spot). There's also a sushi/hibachi inside the Hotel Breakers if that's your thing. Also don't forget Challenge Park and Soak City, and also the lake beach, and a jetski rental/parasailing spot. There really is quite a bit to do without leaving the site. As for the weather, it's usually pretty hot/humid around that time of the summer. The lake breeze helps though.
If you want a more traditional nightlife with some bars and such, I would check out the downtown/waterfront section of Sandusky. It's about 5 minutes from Cedar Point. I don't know if they have any dance clubs at the moment, but I remember a few decent bars/pubs being open last time I was over there. The waterfront will likely be hopping as well, especially if the weather is nice.
One thing I strongly suggest. If you are going to stay on site at a Cedar Point hotel in July, I would reserve the room(s) ASAP. You are going during the busiest month of the season, and you might find it impossible to book the lower cost rooms if you wait too long. Your walking distance, early entry, and cheaper tickets will be replaced with a hotel 5-10 minutes away, and parking fees or a shuttle bus. It's not the most horrible thing in the world, because there are some decent hotels in Sandusky. I would much rather just stay on site and walk for a minute to the front gate, so I would act soon. Have fun you crazy kids!
I've never stayed in one of the cabins. Heard some really good things, but I've just always stayed at the Breakers, or Breakers Express if I'm on more of a budget. The cabins have become fairly pricey at 300 a night for most of the season. They do sleep 6 people though, and have a private deck with grill and a killer view. It's not something I would tell people to dismiss if they are planning a visit, because I've heard nothing but good things about the cottages and cabins, as well as the RV park. If I'm going to lay down that kind of money for a stay though, I'll spend my three hundy plus a night on a concierge or horizon suite at the Breakers.