Enhanced weak force sensing through atom-based coherent noise cancellation in a hybrid cavity optomechanical system