Plans to open a £20 million tennis and sports centre to build a lasting legacy for Sir Andy Murray have been unexpectedly scrapped, bringing a near-decade-long campaign to an end.