There is a way to return the data the way you have structured in the question.
So if I adjust CHills procedure just a little bit:
ALTER PROCEDURE [dbo].[Test]
-- Add the parameters for the stored procedure here
AS
BEGIN
-- Whatever it is you are doing to get a value in @@ROWCOUNT goes here
IF @@ROWCOUNT = 0
BEGIN
SELECT 0 AS [result], 'Success' AS [message]
RETURN 0
END
ELSE
BEGIN
SELECT 1 AS [result], 'Failed' AS [message]
RETURN 1
END
END