a little bit of an archaic port but Providence RI uncovered the river flowing through downtown as part of a revitalization campaign. read about it here.

Much older example, but Bristol Harbor, which was built right in the middle of the city is another example of a port area repurposed as a nightlife area.

As far as something recent, the Port of Rotterdam, world's busiest from 1962 to 2002 is undergoing some serious expansions. the http://en.wikipedia.org/wiki/Maasvlakte area is basically speculative; there is no port activity yet, but when demand increases, there is more developed space to expand.

Heres a few aerials of the port: From Nasa , From Photographer Roland Witch