Plans for luxury holiday lets and wedding venue at Red House in Gomersal scrapped, with Kirklees Council now looking to sell the site