Cardiff Council thanked residents for "some necessary disruption" and said holding the final will have a "long-lasting legacy for the Welsh capital"