Try using the below code:
DECLARE @var nvarchar(max) = 'Man''s best friend';
Note: Since the string delimiter is ' and not ", there is no need to escape ":
You can change the ' is escaped by doubling it to '' like this:
DECLARE @var nvarchar(max) = '"My Name is Luca" is a great song';