Did you move the actual Photos library, or did you move the individual photos? Neither is likely to do what you want, but the recovery will be different. Either way, you will need to put your library/pictures back into the normal file system, then look for another solution to your space shortage.
If you really moved the whole Photos library, you may have done irreparable damage to it and should restore it from your backup (ideally a Time Machine backup).
If you only moved the pictures from the Photos library to Dropbox, you'll have to move the back into the Photos library before you can access them from the Photos app.