The things you will need in Columbia in July or August: plenty of water, a hat, sunglasses and bug spray! But I agree with the suggestions Lisel offered. In addition, if you are willing to shoot some historic buildings, our State House offers some good shots and there is some great architecture around downtown. The River Front Park/Columbia Canal is a great walking trail and based on the shots you have posted in your gallery, you will find plenty to shoot. Send me an email as time gets closer and you know some specific dates and I'll send you information on upcoming events.
Cindy