getting error incorrect syntax near @certificate
I don't know if you can pass a paramater in this situation. Please try to create your query in a variable, like: 

declare @query as nvarchar(255);
set @query = 'drop signature from Report_Manager by certificate ' + @certificate;


and then execute the query like:

EXECUTE sp_executesql @query