A photo album destined for printing has a 'de facto' standard; nearly all printshops I know of accept PDF-files. PDF's can also be used for slideshows/presentations.
Sure, PDF has it's inconveniences; large file sizes, cumbersome editing, etc. LibreOffice offers the possibility of 'hybrid' PDF/ODT files which may be used while editing such files. For advanced PDF-creation for printing, some may prefer real DTP-software such as Scribus, which offers things like advanced colour-management, control of bleeds, and such stuff.
I'm not sure if it's possible in LO (via macro?) to extract EXIF/XMP metadata information (e.g. comments, tags) from an image for use in image captions or accompanying text, at least that would be cool.
ajlittoz mentioned DigiKam, which is a fully fledged Photo-Management system, ideal for tagging, organizing, commenting, batch-handling photographs and has some advanced editing capabilities. As he said, DigiKam does not create any 'virtual' collections/rolls/albums to organize photos; you can use individual tags, a hierarcy of tags, flags, and colour codes to select/identify pictures. And those tags/marks can be written into header metadata of many file formats without altering the photographic data itself. DK supports also creation/reading of sidecar files for this information.
Once the photos have been tagged, the metadata can then be used for making various 'virtual' albums to one's liking; for export to HTML or whatever, slideshows or to drop onto LibreOffice...
Hope this helps a bit.