You do sometimes see a yacht in the Camperdown Dock, but they tend to be staying long term rather than overnight. The Victoria Dock would be the best bet, but I've no idea what the access arrangements are.
Wait 5-10 years though, and the new marina will be built - part of the redevelopment of the city centre..