Is it possible to sync a Photos library hosted on external HD with iCloud?
Is it merely a matter of going into System Preferences → iCloud → and ticking the Photos box?


Yes.


  If it is, I’m guessing I must have the external hard drive (where the Photos library it) connected when I do it, and must be ready to leave it connected for a while (maybe overnight) while it syncs with iCloud?


Yes,