Alternatively you can now simply drag and drop the picture onto the user account.

You’ll need to turn on the iCloud Photo Library before you can use it as a source of profile pictures. Open the Apple Menu, click “System Preferences”, then “iCloud”, then “Preferences” (next to “Photos”). Select “iCloud Photo Library”.