I would do a full dormer on the back of the house facing the water. To keep cost in check forget going out to the beam and just bring the dormer to the exterior wall on the first floor. This is a common dormer.
My best guess would be $110 to $140 a sq' depend on your finishes i.e. flooring,windows,hardware,trim,doors.