Transact SQL :: How To Add UTC Offset To Select Date Query

I have the follwing function in my SQL data base which is hosted in Azure.

All date and time field in my db are store as UTC and I have a function define as below :

ALTER FUNCTION [dbo].[func_GetCurrentLocalTimeFromUTC]
(
)
RETURNS datetime
AS
BEGIN
DECLARE @OffSet as int = 1
DECLARE @CurrentDate as datetime = getUTCdate()

[Code] ...

Now what I have trying to do is to perform a select statement on a table where I have a dateTime value field and add the proper offset value to the field in order it is display based on where user will run the query. For example if I run this simple query :

SELECT INVENTORYDATE from Inventory

Will return the UTC dateTime value.

How can I use the select statement in order to get the field format with proper offset based on user pc timezone/. Please note that the query will be called from a rrs.