2 part travel abroad question- Barcelona or Amsterdam and what to do with beloved/anxious dog while away

After all the WONDERFUL tips, suggestions, etc. - change in plans! We are now going to DUBLIN (for a variety of reasons, not worth going into)! Any suggestions/info, especially surrounding lodging (guessing an Airbnb, apartment, etc. is best for family of 5 adults) is welcome! I so appreciate the collective wisdom/experience here! Thanks again!