Council proud of 'fantastic city' as top tourist destination