I don't know Wakefield very well, but the position close the A1/M62/M1 makes it good for access and distribution so I can see why property is hard to come by.
Economic delevlopment seems to focus on Wakefield First. I had a quick look at their website and under managed workspace you have to scroll a a long way down to find the only non-office space, in South Kirkby which might be too far for you. It does say they have 'creative industries' and you fit that definition. Might be good to give them a call though, they might have contacts.
Wakefield First is a strategic organisation responsible for attracting inward investment, supporting business, trade, and raising the profile of Wakefield.
www.wakefieldfirst.com
You have a successful business which you want to continue, I wonder if you said you had a succesful business which you want to expand (whether you do or not) you might be able to get some support and advice from them?
Wakefield has some railway junctiosn etc., I wonder if network rail have anything to rent? Not looked but here is their website. Demonstrating drums under a railway arch - acoustics to die for (or of?).
Network Rail Property are suppliers of commercial premises and business space to let in the UK. Retail, office, warehouse, railway arches and storage space.
property.networkrail.co.uk
I can see that 'drums' might put some landlords off, wholly irrational but they might see you as some drug-crazed havy metal rocker. But do you make drums? Maybe you make and restore "Orchestral Percussion and drums". A whole lot more respectable sounding, and who knows you might get some new business. Now, you aren't going to rush out and start making tuned percussion like xylophones and marimbas, and certainly not Timpani, but a lot of "orchestral percussion" is essentially drums. OK, not kits, although some repertoire does need a kit, but snares, toms, field drums and so on. Contemporary percussion ensembles play all sorts. Just one example of orchestral kit, this at the economy end.
High Concert Tom Set Consisting of shell sizes 06 "x06", 08 "x07", 10 "x08" and 12 "x09", Shells made of 6 layered, 5 mm thick maple wood, Maple wood selected especially for concert toms, as well as a specific focus on the interconnection between...
www.thomann.de
So - maybe a potential landlord would be happy to house a business which makes and restores high quality orchestral percussion and drums, while you get on making and selling .... drums. You might even get some new business.