If you want to go to Avebury, take the train from Bristol Temple Meads to Chippenham, and then the bus from the timetable on this link; http://www.kennet.gov.uk/planservices/AveburyW.nsf/avebury_transport.htm
Stoney Littleton and Stanton Drew definitely needs a car.. way out in the country.
Moss