Just a guess but it's probably something to do with this chap.
"Admiral Lord Viscount Duncan of Camperdown was born in Dundee on 1st July 1731. In a naval career spanning fifty-four years, he saw early service in the search for Prince Charles Edward Stuart off the West coast of Scotland, and afterwards with the British Navy in the Mediterranean, America, West Africa and Cuba. In his later years he earned wide respect for his handling of the serious naval mutiny of 1797, but achieved his greatest fame through his remarkable defeat of the Dutch fleet under Admiral de Winter off Camperdown on the 11th October 1797, thus thwarting a possible invasion by French and Dutch troops. He was made a Viscount on 17th October 1797 and died on 4 August 1804. In the words of Admiral Lord Nelson, 'the name of Duncan will never be forgot by Britain and in particular by its Navy'."
Either that or it's named after a gay bar on Old Compton street that was blown up in '99.................perhaps not.