I would wholeheartedly recommend Maes Knoll, it can't be too bad a walk uphill from Whitchurch on the south of the city, and the views of Bristol and all round are amazing.
http://www.themodernantiquarian.com/site/2882