Yes, it will work. The official high resolution texture pack is compatible with the base game or any of the DLC.
You will have problems though if running a 32-bit operating system.
You will need a 64-bit operating system and at least 6GB of RAM.
You can also improve the graphics significantly with mods.
Some of these will require a graphics card with at least 2GB of video memory (with MSAA disabled) or higher if you also want to enable MSAA with mods installed.
Visit
http://www.nexusmods.com/skyrim
Here is a list of the graphics mods I use and the order to install them:
Unofficial Skyrim Patch-19-1-3-2c.7z
Unofficial Hearthfire Patch-25127-1-1-1.7z
Unofficial High Resolution Patch-31255-1-1-2.7z
SkyUI_4_1-3863-4-1.7z
Ruins_Clutter_Improved_v2-5 NMM Installation-14227-2-5.7z
Better Dynamic Snow 2-20-10383-2-20.7z
SMIM v1-46-8655-1-46.7z
Skyrim HD v1_5 LITE - Dungeons-607.7z
Skyrim HD v1_5 LITE - Landscape-607.7z
Skyrim HD v1_5 LITE - Misc-607.7z
Skyrim HD v1_5 LITE - Towns-607.7z
Skyrim HD v1_6 LITE - Riften-607-1-6.7z
Skyrim Flora Overhaul Basic v181b-141-v1-81b.7z
Detailed_Faces-2_00-26-2-0.7z
No_More_Blocky_Faces-1_50-30-1-5.7z
jewels of the nord - high res-27038-1-2.rar
Detailed_Rugs_v1-3-29608-1-3.7z
Glowing Ore Veins 300 2_00-193-1.rar
Enhanced Night Skyrim v04 Low Stars-85-0-4.zip
Enhanced Night Skyrim v04 Color Galaxy-85-0-4.zip
WATER 1_71-13268-1-71.7z
Realistic Lighting Overhaul 4_0_7c NMM-BAINWizard Installer-30450-4-0-7c.7z