Campaigners are celebrating after a controversial bid to convert a historic pub into “another vape shop” was rejected.