A former police station in Knowsley, which dates back to the late 1800s, is to be transformed into affordable homes under newly backed plans.