A Queen's Ransom - George Lazenby (1976) - Aberdeen Harbour, Aberdeen

I think most of the following screen grabs from the film are actually the snippets from the archive footage of the Royal visit. There are some nice views around the harbour including the Sea Palace, Tai Pak and a quick glimpse of what I think must be the Yue Lei Tai (second picture top left) floating restaurants.

I can't tell exactly from the film but it looks as though the Royal visitors were seated at the front of the Tai Pak for a water-based carnival. In the film the bad guys want to stick a bomb to the restaurant to blow her up.