A former car showroom is set to be transformed into a petrol station, complete with a number of food outlets, on a main route through Rotherham.