Roker Pier and lighthouse has reopened to the public after being closed for nearly two years following damage from Storm Babet.