The declaration of an anonymous block is wrong, you should use DO $$ and END $$. In sql use INTEGER, plpgsql only accepts the integer keyword. This is how you should write.
DO $$
DECLARE
c INTEGER;
BEGIN
EXECUTE 'SELECT count(1) FROM my_dwh.accounts' INTO c;
RAISE NOTICE 'Count: %', c;
END $$;
I hope this is the answer you are looking for.