Council backs BP show for Aberdeen art gallery