Northamptonshire country manor boss apologises for ‘musicians to work for free’ request after huge social media backlash