Rotherham Metropolitan Borough Council is set to purchase an industrial property to make way for the development of a new mainline and tram train station.