Council rated most gay-friendly in the country