From My Bloody Valentine to Saint Etienne and Ricardo Villalobos, Andrew Weatherall sprinkled magic throughout his career