Not only is Raffles Marina Lighthouse a popular phototaking spot, you can also fish there and even book a staycation over the weekend