I'd also throw out the Waterside area as an option if you're concerned about noise and don't care about being near nightlife. It's across the water from Harbor Point. We live at Harbor Landing Apartments and mostly like it.

Our unit is close to the street and there's some noise from traffic but it's not too bad (I'm also a very sensitive sleeper) and certainly much less traffic than downtown. Units towards the back should be pretty quiet. There are also more buildings further down the street. Baypointe is nicer, more expensive and a bit further from the street as well but you also get further away from the train station so it's a trade-off.

I think the best part about the area is it's great for dog walking. There's a boardwalk that goes all the way from our building along the water down to a (small) park. Overall this side of the water seems to be a bit cheaper than Harbor Point.

Are you planning on leaving your dog at a day care while you're out at work? Then you might want to consider that location as well.