Yes, and you don’t even need to pass the destination name if it is the same as the source (if your current directory is ~/ of course…)
ln -s ~/Library/CloudStorage/Dropbox
ln -s ~/Library/CloudStorage/Dropbox
(I suspect it will as a folder is a folder as far as the OS is concerned, but I haven't tinkered much with symlinks).