A new café has opened at the site of a former Fareham museum which was closed in 2024.