Bristol neighbourhood's last pub saved after years of uncert