Yes, you can delete the stockpile and place it anywhere you want. Be careful when deleting your stockpile as you will lose any goods stored on it.