I would recommend a couple of places:
The Pearl is an old brewery that has been converted into an area of bars, restaurants and shops. On Saturdays and possibly Sundays there is a great farmer's market there with food and live music. It is on the north end of the River Walk a.k.a the Museum...