Carlisle's war memorial has been successfully moved to a more prominent location in the city centre ahead of Remembrance Sunday.