A Bristol garden featured in a David Attenborough-narrated BBC series has highlighted the role of urban spaces in supporting wildlife.