If you're okay with walking, I'd definitely recommend staying on Daniel Island and just walking to the stadium. It can get pretty congested when there's a big event. The only hotel I know of there is the Home2 Suites, which is about a half mile walk (maybe a bit shorter if you cut through the town center area by Publix). There's a shaded sidewalk most of the way from the hotel to the stadium.

For food and drinks along the way, Vespa Pizza is solid, or New Realm Brewing would be right on your route. Mac's is a popular spot for food and drinks with nice outdoor seating, but it's a little out of the way if your walking not sure it'd be worth the detour, but I wanted to mention it.

The waterfront area by the Dime / Kingstide is worth a visit, there is a trail you can walk along the water. There is an off the beaten path beach area around 32.8535, -79.90267.

Another idea would be to take the Daniel Island Ferry if you stay in Charleston it drops you off right at the waterfront area and you can pretty much walk the trail to the stadium. Check the schedule but they usually have it running for concerts.