A popular Wiltshire venue has celebrated its grand reopening with a performer who played with Ed Sheeran after coming under new management.