A wizard-themed holiday let above the café where JK Rowling famously wrote Harry Potter has been rejected despite claims it is the only way to bring the building back to life.