You can do the escaping by using two apostrophes.
Consider the following
SELECT '''Some data'''
However, I don't think you need to escape the apostrophes since you can pass the whole name inside a variable to the procedure. Try using
sp_rename @objname = @old_comlumn_name_variable , @newname = @new_column_name_variable, 'COLUMN'