Birmingham Council said it wants to aim for a 'climate resilient future' in a major vision for the city