Try:
SELECT d.departartmentName,
SUM(CASE WHEN e.objective_Status=1 THEN 1 ELSE 0 END) AS TotalLive,
SUM(CASE WHEN e.objective_Status=2 THEN 1 ELSE 0 END) AS TotalDraft,
SUM(CASE WHEN e.objective_Status=3 THEN 1 ELSE 0 END) AS TotalCompleted
FROM Employee e
JOIN Departments d
ON e.DepartmentId = d.DepartmentId
GROUP BY departmentName