But when the tiny Waterfront Museum and Showboat Barge in Brooklyn announced three years ago that it needed to make some major capital improvements , the news was received in its neighborhood , along the mangy Red Hook waterfront , with the trepidation that usually accompanies a renovation sign on the door of a favorite restaurant .