That's something to look forward to! Will you be celebrating in Dublin or elsewhere on the Emerald Isle?
Most cities will have official lightshows or fireworks displays to celebrate the new year. If your dog is not happy around fireworks you might want to check what the local city council has planned.
With regards to taking children it would depend a little bit on how old they are. Ireland is generally very safe but people will be celebrating during the course of the evening!
A family-friendly option is for instance the Liffey Lights show
at the Dublin Custom House.
I hope this is helpful! If you need more information please let us know, we'll be happy to help make the most of welcoming the new year on our green island.